Select
  Country.Country,
  Genre.MainGenre,
  Aantal
From  

(Select
  Country.Country,
  Genre.MainGenre,
  count(Genre.MainGenre) as Aantal
From

(Select distinct
  Country.Country,
  ArtistPerson.Name,
  Genre.MainGenre

From
  ((((((ArtistPerson Inner Join
  Country On ArtistPerson.CountryID = Country.CountryID) Inner Join
  ArtistAlbumLink On ArtistPerson.ArtistPersonID =
    ArtistAlbumLink.ArtistPersonID))) Inner Join
  Album On ArtistAlbumLink.AlbumID = Album.AlbumID) Inner Join
  GenreAlbumLink On Album.AlbumID = GenreAlbumLink.AlbumID) Inner Join
  Genre On GenreAlbumLink.GenreID = Genre.GenreID
  
)

Group By
  Country.Country,Genre.MainGenre)

Order By
  Aantal desc,Country.Country
